package com.dailyblue.java.project.power.mapper;

import com.dailyblue.java.project.power.bean.Powers;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PowersMapper {
    @Select("select * from powers")
    List<Powers> findAllPower();

    @Select("select * from powers where id in (select pid from user_power where uid=#{uid})")
    List<Powers> findPowerByUserId(int uid);
}
